Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mONTH cOMPARISON
I have an excel spreadsheet that takes a date in cell b1 (1/25/206) and ads
7days to it (the new date becomes 2/1/2006) and ecords the new date in cell b2. What I want to do is if the new value in (ie 2/1/2006) is in a differnt monththan te originating date then cell b2 woould reocrd the word avg instead of the date 2/1/2006. Howdo I do this? I am using vba. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
mONTH cOMPARISON
In B2:
=if(month(B1+7)<Month(B1),"avg",B1+7) format the cell as Date -- Regards, Tom Ogilvy "Roy" wrote: I have an excel spreadsheet that takes a date in cell b1 (1/25/206) and ads 7days to it (the new date becomes 2/1/2006) and ecords the new date in cell b2. What I want to do is if the new value in (ie 2/1/2006) is in a differnt monththan te originating date then cell b2 woould reocrd the word avg instead of the date 2/1/2006. Howdo I do this? I am using vba. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel to make the days cary over month to month automaticly | New Users to Excel | |||
Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
copy worksheet from previous month and rename to current month | Excel Programming | |||
Showing data per month & year for comparison | Excel Discussion (Misc queries) | |||
transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) |