Formula Help Please

nancybrown

Well-known Member
Joined
Apr 7, 2005
Messages
868
My spreadsheet has a date fields, I added a field with today's date and subtracted the two columns to get # of days late. My goal is to create a chart that tells how many entries are 30 days late, 45 days late, 60, 90, 120, and >120. Can anyone help with an If statement please?
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

nancybrown

Well-known Member
Joined
Apr 7, 2005
Messages
868
Hi thanks, but I'm not sure I understand how this will give me what I need.

I need to look at the number in B2 and if the number is < or = "30" then return results of "30 Days", next is If B2 >= "31", but <="45" then results are "45 days".
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,950
Messages
5,508,324
Members
408,678
Latest member
ripperbolt

This Week's Hot Topics

Top