Hi
Attached excel file...Please tell me a formula to make values/dates appear in column D identical to column C (using column B).
It looks like you just need a Custom NumberFormat
YYYY-MM
I can't see the point but a formula in C3
=TEXT(B3,"yyyy-mm")
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Thanks for help
May you please suggest without using text function?
Please....
The formula will work but should be in cell D3... So in cell D3 enter the formula
=TEXT(B3,"yyyy-mm")
Without the text function try this in cell D3
=YEAR(B3)&"-"&IF(LEN(MONTH(B3))=2,MONTH(B3),"0"&MONTH(B3))
Last edited by adaws; 01-24-2012 at 07:53 AM.
In D3
=A3
Format cells as "yyyy-mm" in the format cells dialag -> custom number
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Please also tell me (a formula) to calculate:
-No. of days in the month in column E
-Last day of the month in column F
Thanks in advance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks