| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=DATE(YEAR(P4),MONTH(P4)+1,1)
I cant seem to get his one right.
How can revise this formula so the cell is blank until data is typed in P4 cell Please advise |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=DATE(YEAR(P4),MONTH(P4)+1,1)
=IF(P4="","",DATE(YEAR(P4),MONTH(P4)+1,1))
-- Gary''s Student - gsnu200828 " wrote: I cant seem to get his one right. How can revise this formula so the cell is blank until data is typed in P4 cell Please advise |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=DATE(YEAR(P4),MONTH(P4)+1,1)
;193661 Wrote: I cant seem to get his one right. How can revise this formula so the cell is blank until data is typed in P4 cell Please advise Hi try =if(p4="","",DATE(YEAR(P4),MONTH(P4)+1,1)) -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=53409 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=DATE(YEAR(P4),MONTH(P4)+1,1)
You may even want:
=if(isnumber(p4),DATE(YEAR(P4),MONTH(P4)+1,1),"") wrote: I cant seem to get his one right. How can revise this formula so the cell is blank until data is typed in P4 cell Please advise -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| Date -Month/day/year | Excel Discussion (Misc queries) | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}))' | Excel Worksheet Functions | |||
| I need date format to be set up as month/year. | New Users to Excel | |||
Linear Mode
