Hi, wondering how I get the following into an excel formula...
1st day of month for 2nd full month worked from start date, although only after 1/5/2014
see attachment
start date date (1st day of month for 2nd full month)
Hi, wondering how I get the following into an excel formula...
1st day of month for 2nd full month worked from start date, although only after 1/5/2014
see attachment
start date date (1st day of month for 2nd full month)
Not sure what you are trying to do
Explain it in a better way with expected result![]()
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
May be this.....
In D6
and copy down.![]()
Please Login or Register to view this content.
Is this what you are trying to achieve?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
for example if the date was > 1/5/14 the result would be
1/5/2014 start date then two month- would be 1/7/14
but if it was a start date of
9/5/2104 the 2nd full month worked would be 9/8/14, but i want a date returned of 1/8/14
i only want dates after the 1/5/2014 though to appear..
In D9 Cell
=DATE(YEAR(B9),MONTH(C9),DAY(B9))
Drag it down...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks